SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Privately sited on beautifully landscaped grounds in the coveted Mulherrin Farm neighborhood, this impeccably maintained three-bedroom Colonial blends timeless New England architecture with thoughtfully designed living spaces and exceptional indoor-outdoor appeal. Surrounded by mature landscaping and offering a peaceful sense of privacy, this exceptional home is just minutes from Hanover, Dartmouth College, DHMC, and is within the Hanover School District for K-12. The beautifully appointed kitchen flows seamlessly into a stunning vaulted living area featuring exposed beams, a cozy gas fireplace, and oversized windows that fill the space with abundant natural light while framing picturesque views of the surrounding landscape. Rich architectural details and an open, inviting floor plan create an atmosphere that is both elegant and welcoming. The spacious primary suite serves as a private retreat, complete with a generous walk-in closet and a well-appointed ensuite bath. Above the oversized two-car garage, an impressive 27' x 16' heated bonus room with electricity provides exceptional flexibility as a home office, media room, fitness studio, playroom, guest suite, or creative workspace. A partially finished basement offers additional living space ideal for a recreation room, home gym, hobby area, or abundant storage. Step outside to the inviting screened porch, the perfect place to enjoy your morning coffee, entertain guests, or unwind while overlooking the beautifully landscaped grounds. Whether hosting gatherings or savoring a quiet evening surrounded by nature, the outdoor spaces are every bit as inviting as the home's interior. Combining quality craftsmanship, architectural character, and an exceptional location in one of the Upper Valley's most desirable neighborhoods, this is a rare opportunity to enjoy a lifestyle of comfort, privacy, and convenience. OPEN HOUSE Sunday 8/30 from 10 AM- 12:00. See you there!
Description:This substantial expanded Cape on 107 ancres offers an exceptional blend of multi-generational living, extensive workspace, and expansive acreage. The main residence features five bedrooms and four and a half bathrooms, anchored by a beautiful Crown Point Cabinetry kitchen equipped with abundant cabinet and counter space, a woodstove, and direct access to a porch designed for summer dining. A large, elegant living room centers around a classic Rumford fireplace. Recent updates include a new oil-fired boiler with ten heating zones alongside a whole-house generator. A two-car garage provides convenient attached parking. Complementing the main house is a detached guest house featuring a character-rich post and beam upper frame with a sleeping loft and a full bathroom. For projects and storage, the property includes a 24x60 storage building and a premier 24x44 workshop outfitted with radiant floor heat, an 80-gallon compressor, and a 2,000-pound traveling hoist. Set on 107.5 acres, the grounds feature an in-ground saltwater swimming pool, an established pond, a seasonal brook, and an extensive network of trails and wood roads. Beautiful landscaping frames the home, complete with mature plantings of blueberries, rhubarb, and Christmas trees, creating a private and versatile rural retreat.
Description:This charming 3-season home on beautiful 1158-acre Mascoma Lake has been lovingly cared for by the same family for over 50 years, and now it’s ready for its next chapter. Nestled on 0.71 private acres with 210 feet of pristine waterfront, this 3-bedroom, 4-bath retreat invites you to slow down and savor lakeside living. Whether you're floating in the peaceful waters, relaxing in the sunken spa within the detached sunroom, enjoying a sunset from the mahogany deck, or strolling down the quiet, tree-lined road, every moment here feels like a getaway. Listen to the sound of the loons and watch the eagles soar. Nature's beauty is right at your doorstep. A 42-foot aluminum dock with new thru-flow decking stretches into the deep water, ideal for boating, fishing, or simply soaking in the beauty of the surroundings. Cedar shake siding adds timeless appeal, while the whole-house standby generator offers convenience and peace of mind. Inside, floor-to-ceiling windows bring the lakefront views right into the living space, and thoughtful updates throughout provide comfort and function. Though currently used as a 3-season home, it holds the potential to be enjoyed year-round with a few modifications. Here, the days feel longer, the air is a little sweeter, and the lake feels like it’s all your own.
Description:A rare opportunity in the heart of Hanover! Known as the former “David’s House,” this historic property was originally built in 1880 and has been renovated and updated throughout the years. Offering over 3,000 square feet of living space, 9 bedrooms, and 5 bathrooms, this property provides tremendous flexibility and potential. The third floor features a separate one-bedroom apartment, offering additional possibilities for rental income, guests, extended family, or private living space. The property is served by town water and sewer and features a built-in sprinkler system, fire escapes, walkout partially finished lower level, and a warm and inviting covered front porch. A large parking area with road frontage on both Prospect Street and West Street adds to the property's versatility and accessibility. While the home may require renovations to return it to a traditional single-family residence, the possibilities are substantial. With its prime in-town location, historic character, generous square footage, third-floor apartment, town utilities, and unique access from two streets, this is a compelling investment opportunity in Hanover. Bring your vision and unlock the potential of this truly special property!
Description:For the first time in nearly 250 years, this remarkable 1780 colonial is being offered for sale. Thoughtfully cared for by the same family for generations, this exceptional 52-acre estate offers a rare opportunity to own a piece of New Hampshire history in the heart of Lyme. As you pull into the driveway, you're welcomed by rolling fields, mature hardwoods, and the peaceful setting that makes this property truly special. Inside, you'll find hand-hewn beams, wide pine floors, abundant natural light, four bedrooms, two bathrooms, a full basement, and timeless craftsmanship that reflects the history and character of this remarkable home. A drilled well, newer septic system, and an automatic-feed pellet furnace with oil baseboard backup provide modern convenience while complementing the home's historic character. Step outside to discover a four-stall horse barn complete with a tack room, fenced riding area, a network of mowed trails, a four-bay pole barn, multiple outbuildings, an oversized garage equipped with a professional-grade lift capable of servicing one ton trucks, and a fenced backyard. Beyond the buildings, the 52 acres offer a beautiful blend of open fields and mature hardwood forest, all enrolled in Current Use, creating plenty of room for horses, recreation, farming, or simply enjoying the surrounding landscape. Despite its private country setting, you're just 10 minutes from Lyme Elementary and Middle School, 15 minutes from Hanover, Dartmouth College, and I-91, and only 20 minutes from Dartmouth Health.
Description:Don't miss out on this incredible opportunity to own a beautiful commercial/residential zoned property in a highly visible area of Hanover, NH. Ideallysituated right on Route 10 (Lyme Road), just minutes from downtown Hanover and within walking distance of the elementary and middle schools, this property features agorgeous post and beam building connected by a breezeway to an additional building, with plenty of parking. Constructed by the renowned Timberpeg builders, the mainbuilding offers 3 levels of finished space, including a vaulted ceiling entryway suffused with natural light, a suite of offices, most of which feature en-suite bathrooms, aspacious shared kitchen, and a media room. The smaller building is a versatile 2-story space, originally built as a squash court, but ripe for use as a yoga studio, retailspace, or apartments. The newer zoning status allows for 49% of the buildings to be converted into residential living space, opening up endless possibilities for a buyer.This property has been beautifully maintained and updated over time, including a high-efficiency pellet boiler to help reduce expenses and carbon footprint. Take advantage of this unique Hanover offering and bring your ideas!
Description:Discover a quietly captivating Contemporary, where natural light pours in and the landscape becomes an ever-present part of the experience. Nearly every room frames a view, inviting you to slow down, settle in, and savor the setting. Thoughtfully designed gathering spaces offer both openness and intimacy. Host dinners in the formal dining room, linger over morning coffee in the breakfast nook, or curl up by the fire as the hillside shifts with the seasons. With generous proportions, the living areas adapt beautifully, whether entertaining, unwinding, or simply living with ease. For those who work from home, a full-size office with built-in bookshelves and expansive windows provides an inspiring place to spend your days. The kitchen is functional, crafted for those who love to cook and connect. A nearby pantry and direct-access mudroom streamline daily routines and arrivals. The east wing features three main-level bedrooms and two full baths, creating both comfort and flexibility. Upstairs, the primary suite feels like a private retreat; wrapped in windows on three sides, filled with soft light, and oriented toward serene northern views. A walk-in closet and full bath with a double vanity complete this sanctuary-like space. A full unfinished basement offers abundant storage, laundry, and direct outdoor access. Outside, rolling lawn, mature landscaping, a solar tracker, and apple trees blend seamlessly with the open field beyond.
Description:Located off of picturesque River Road in the lovely cul-de-sac neighborhood of Purling Brooks, this spacious, light-filled five bedroom, five bathroom home offers an exceptional blend of comfort, flexibility, and natural beauty. A welcoming front porch overlooking mature gardens creates a perfect spot to relax and enjoy the peaceful surroundings and expansive yard. The neighborhood abuts conservation land and scenic walking trails. A standout feature is the private accessory dwelling unit (ADU), with its own kitchen, living room, bedroom, bathroom and laundry- a versatile space for guests, extended family, a nanny, or potential rental income. The main home’s open-concept kitchen flows seamlessly into a spacious living room highlighted by soaring cathedral ceilings and a cozy propane fireplace. From the living room, step into the inviting three-season screened porch—an ideal retreat for relaxing, entertaining, or enjoying the private surrounding yard. The main level also includes a formal dining room, comfortable living room and a bedroom, which could easily serve as a private office or bonus room. Upstairs, the expansive primary bedroom ensuite features three walk-in closets, complemented by two additional bedrooms, a bathroom, a dedicated office or activity area, and a convenient second-floor laundry room. The large finished basement provides abundant space for recreation, entertainment, a potential sixth bedroom, and storage. Set in a desirable neighborhood with direct access to nature, this exceptional home offers space and versatility. A truly wonderful place to call home. Seller is a licensed real estate agent.
Description:Perfectly positioned along the Connecticut River in Hanover, 32 River Road offers a rare blend of refined living and extraordinary natural beauty. This thoughtfully updated three-bedroom, three-bath residence captures sweeping river views and an effortless indoor-outdoor lifestyle in one of the Upper Valley’s most desirable settings.Renovated in 2021, the kitchen, family room, and baths feature clean, timeless finishes, while hardwood floors and radiant heat throughout the lower level and garage provide year-round comfort. Cathedral ceilings introduce natural light and volume, while loft spaces accessed by custom ladders add charm, flexibility, and a perfect hideaway for younger guests. Clapboard siding and a standing seam metal roof complete the home’s understated New England aesthetic. The home’s 700+ square-foot wraparound deck serves as the centerpiece of the property, offering panoramic river views and exceptional space for entertaining, dining, or quiet retreat. Whether enjoying morning coffee beside the water, evenings in the hot tub, or sunset gatherings with friends, every moment is framed by the rhythm and beauty of the Connecticut River. A private dock provides access to rowing, paddling, boating, and exploration. Included in the offering are a Vespoli racing shell, canoe, kayak, and motorized raft, along with amenities including dedicated gear storage, an outdoor summer shower, and a heated two-car garage. In the early morning hours, Dartmouth crew shells glide quietly along the river, adding to the timeless character of life on the Connecticut. Adding to the property’s appeal is an additional 10-acre parcel across the street, where carved walking trails and several potential building sites offer future possibilities. The river becomes part of daily life in every season, creating a rare sense of privacy and connection to nature just moments from downtown Hanover and Dartmouth College. Offered with tasteful furnishings-this is a turn key opportunity.
Description:Set on 40+/- private acres in Hanover, this exceptional 4 bedroom, 3.5 bath home offers breathtaking long range mountain views, stunning sunsets, and peaceful field vistas. Enjoy the beauty of every season from your own backyard, surrounded by perennial gardens, abundant wildlife, and the sounds of birdsong. As day turns to night, take in spectacular stargazing, where the stars shine brightly above the surrounding mountain and fields. Filled with natural light, nearly every room captures stunning views of the surrounding mountains, fields, and landscape. Inside, you'll find hardwood and tile floors, a spacious laundry room, and a chef’s kitchen featuring beautiful quartz countertops and ample space for gathering and entertaining. Step directly from the kitchen onto the expansive deck, where you can enjoy your morning coffee, watch wildlife, and take in the spectacular scenery. The inviting sunroom provides another peaceful space to relax and appreciate the ever changing views throughout the year. Cozy up by the woodstove on winter days while enjoying the warmth and charm of this thoughtfully designed home. Additional features include a 2 car garage, abundant attic storage, and a partially finished walkout basement complete with a full bath ideal for a game room, home gym, guest space, or recreation area. Step outside to the expansive yard where panoramic mountain and field views stretch for miles. With easy access to hiking trails right from your doorstep, outdoor enthusiasts will appreciate the opportunity to explore nature without ever getting in the car. Located just minutes from Hanover, Dartmouth, shopping, dining, and recreation, this property offers a rare combination of privacy, natural beauty, and convenience in one of the Upper Valley's most sought-after locations. Whether enjoying a sunset from the deck or sunroom, relaxing by the woodstove, or exploring the surrounding trails, this remarkable property is a true Upper Valley retreat.